﻿CREATE TABLE [dbo].[FoodIngredients] (
    [FoodIngredientID]      INT            IDENTITY (1, 1) NOT NULL,
    [IngredientName]        NVARCHAR (50)  NOT NULL,
    [Quantity]              NVARCHAR (MAX) NOT NULL,
    [IngredientDescription] NVARCHAR (MAX) NULL,
    [HealthRatingID]        INT            NULL,
    [UserID]                INT            NULL,
    [NutritionInfoID]       INT            NULL,
    [DateTimeStamp]         DATETIME       NOT NULL
);

